Finance teams frequently prepare journals in Excel and then transfer the data to Microsoft Dynamics 365 Business Central. Without help, files need to be reformatted before uploading or entered manually, which is time-consuming.

Excel Importer solves this problem.

Import data the way you receive it, without changing the file format:

Import journals, sales and purchase orders/invoices, sales, and vendor price-lists
Import item journals with item tracking information (lot and serial number)
Apply flexible field mappings of column layouts to source data
Apply default values to fields not present in the source data. E.g., default a quantity or dimension specific to the import
Translate source data values to correct accounts and dimensions in Microsoft Dynamics 365 Business Central

This app supports both the Essentials and Premium editions of Microsoft Dynamics 365 Business Central.

This app is supported in all countries, where Microsoft Dynamics 365 Business Central is available.

The app is available in English, Dutch, French, German, Italian, Spanish, Danish and Japanese.